Exam Question Format
You are given five to ten customer problems each with a unique, large data set, a CDH cluster, and four hours. For each problem, you must implement a technical solution with a high degree of precision that meets all the requirements. You may use any tool or combination of tools on the cluster (see list below) -- you get to pick the tool(s) that are right for the job. You must possess enough industry knowledge to analyze the problem and arrive at an optimal approach given the time allowed. You need to know what you should do and then do it on a live cluster under rigorous conditions, including a time limit and while being watched by a proctor.
Evaluation, Score Reporting, and CertificateYour exam is graded immediately upon submission and you are e-mailed a score report within three days of your exam. Your score report displays the problem number for each problem you attempted and a grade on that problem. If you fail a problem, the score report includes the criteria you failed (e.g., “Records contain incorrect data” or “Incorrect file format”). We do not report more information in order to protect the exam content. Read more about reviewing exam content on the FAQ.
If you pass the exam, you receive a second e-mail within a week of your exam with your digital certificate as a PDF and your license number.
Audience and PrerequisitesCandidates for CCP Data Engineer should have in-depth experience developing data engineering solutions and a high-level of mastery of the skills above. There are no other prerequisites.
The CCP Data Engineer exam was created to identify talented data professionals looking to stand out and be recognized by employers looking for their skills. Outside of having hands-on experience in the field, it is recommended that professional looking to achieve this certification start by taking Cloudera's Spark and Hadoop Developer training course.
Required SkillsData IngestThe skills to transfer data between external systems and your cluster. This includes the following:
Import and export data between an external RDBMS and your cluster, including the ability to import specific subsets, change the delimiter and file format of imported data during ingest, and alter the data access pattern or privileges.Ingest real-time and near-real time (NRT) streaming data into HDFS, including the ability to distribute to multiple data sources and convert data on ingest from one format to another.Load data into and out of HDFS using the Hadoop File System (FS) commands.Transform, Stage, StoreConvert a set of data values in a given format stored in HDFS into new data values and/or a new data format and write them into HDFS or Hive/HCatalog. This includes the following skills:
Convert data from one file format to anotherWrite your data with compressionConvert data from one set of values to another (e.g., Lat/Long to Postal Address using an external library)Change the data format of values in a data setPurge bad records from a data set, e.g., null valuesDeduplication and merge dataDenormalize data from multiple disparate data setsEvolve an Avro or Parquet schemaPartition an existing data set according to one or more partition keysTune data for optimal query performanceData AnalysisFilter, sort, join, aggregate, and/or transform one or more data sets in a given format stored in HDFS to produce a specified result. All of these tasks may include reading from Parquet, Avro, JSON, delimited text, and natural language text. The queries will include complex data types (e.g., array, map, struct), the implementation of external libraries, partitioned data, compressed data, and require the use of metadata from Hive/HCatalog.
Write a query to aggregate multiple rows of dataWrite a query to calculate aggregate statistics (e.g., average or sum)Write a query to filter dataWrite a query that produces ranked or sorted dataWrite a query that joins multiple data setsRead and/or create a Hive or an HCatalog table from existing data in HDFSWorkflowThe ability to create and execute various jobs and actions that move data towards greater value and use in a system. This includes the following skills:
Create and execute a linear workflow with actions that include Hadoop jobs, Hive jobs, Pig jobs, custom actions, etc.Create and execute a branching workflow with actions that include Hadoop jobs, Hive jobs, Pig jobs, custom action, etc.Orchestrate a workflow to execute regularly at predefined times, including workflows that have data dependencies